Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 20000 |
| Missing cells | 8261 |
| Missing cells (%) | 2.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.4 MiB |
| Average record size in memory | 128.0 B |
Variable types
| NUM | 10 |
|---|---|
| CAT | 6 |
name has a high cardinality: 19768 distinct values | High cardinality |
host_name has a high cardinality: 6517 distinct values | High cardinality |
neighbourhood has a high cardinality: 217 distinct values | High cardinality |
last_review has a high cardinality: 1507 distinct values | High cardinality |
last_review has 4123 (20.6%) missing values | Missing |
reviews_per_month has 4123 (20.6%) missing values | Missing |
minimum_nights is highly skewed (γ1 = 25.17996962) | Skewed |
name is uniformly distributed | Uniform |
id has unique values | Unique |
number_of_reviews has 4123 (20.6%) zeros | Zeros |
availability_365 has 7176 (35.9%) zeros | Zeros |
Reproduction
| Analysis started | 2021-10-02 05:39:28.425646 |
|---|---|
| Analysis finished | 2021-10-02 05:40:26.994624 |
| Duration | 58.57 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 20000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18923800.78 |
|---|---|
| Minimum | 2539 |
| Maximum | 36485609 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 156.2 KiB |
Quantile statistics
| Minimum | 2539 |
|---|---|
| 5-th percentile | 1193873.85 |
| Q1 | 9393540.5 |
| median | 19521168.5 |
| Q3 | 29129358.75 |
| 95-th percentile | 35275607.45 |
| Maximum | 36485609 |
| Range | 36483070 |
| Interquartile range (IQR) | 19735818.25 |
Descriptive statistics
| Standard deviation | 11012232.42 |
|---|---|
| Coefficient of variation (CV) | 0.5819249812 |
| Kurtosis | -1.233322955 |
| Mean | 18923800.78 |
| Median Absolute Deviation (MAD) | 9896304 |
| Skewness | -0.07538052651 |
| Sum | 3.784760157e+11 |
| Variance | 1.212692628e+14 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 32493112 | 1 | < 0.1% | |
| 2728293 | 1 | < 0.1% | |
| 30741302 | 1 | < 0.1% | |
| 5354796 | 1 | < 0.1% | |
| 36308266 | 1 | < 0.1% | |
| 31194309 | 1 | < 0.1% | |
| 15509545 | 1 | < 0.1% | |
| 13073701 | 1 | < 0.1% | |
| 20775370 | 1 | < 0.1% | |
| 169152 | 1 | < 0.1% | |
| Other values (19990) | 19990 | > 99.9% |
| Value | Count | Frequency (%) | |
| 2539 | 1 | < 0.1% | |
| 3831 | 1 | < 0.1% | |
| 5022 | 1 | < 0.1% | |
| 5121 | 1 | < 0.1% | |
| 5203 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 36485609 | 1 | < 0.1% | |
| 36485057 | 1 | < 0.1% | |
| 36480292 | 1 | < 0.1% | |
| 36479723 | 1 | < 0.1% | |
| 36478343 | 1 | < 0.1% |
| Distinct | 19768 |
|---|---|
| Distinct (%) | 98.9% |
| Missing | 7 |
| Missing (%) | < 0.1% |
| Memory size | 156.2 KiB |
| Hillside Hotel | 7 |
|---|---|
| Brooklyn Apartment | 7 |
| Private Room | 6 |
| New york Multi-unit building | 6 |
| Home away from home | 6 |
| Other values (19763) |
| Value | Count | Frequency (%) | |
| Hillside Hotel | 7 | < 0.1% | |
| Brooklyn Apartment | 7 | < 0.1% | |
| Private Room | 6 | < 0.1% | |
| New york Multi-unit building | 6 | < 0.1% | |
| Home away from home | 6 | < 0.1% | |
| Private room in Manhattan | 5 | < 0.1% | |
| Cozy Room | 5 | < 0.1% | |
| Cozy Private Room | 4 | < 0.1% | |
| Private room in Williamsburg | 4 | < 0.1% | |
| Private room in Brooklyn | 3 | < 0.1% | |
| Other values (19758) | 19940 | 99.7% | |
| (Missing) | 7 | < 0.1% |
Unique
| Unique | 19599 ? |
|---|---|
| Unique (%) | 98.0% |
Length
| Max length | 179 |
|---|---|
| Median length | 36 |
| Mean length | 36.8906 |
| Min length | 1 |
host_id
Real number (ℝ≥0)
| Distinct | 17027 |
|---|---|
| Distinct (%) | 85.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 67460344.07 |
|---|---|
| Minimum | 2571 |
| Maximum | 274273284 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 156.2 KiB |
Quantile statistics
| Minimum | 2571 |
|---|---|
| 5-th percentile | 779450 |
| Q1 | 7853718.25 |
| median | 31114309.5 |
| Q3 | 106842560 |
| 95-th percentile | 242095840.9 |
| Maximum | 274273284 |
| Range | 274270713 |
| Interquartile range (IQR) | 98988841.75 |
Descriptive statistics
| Standard deviation | 78579364.8 |
|---|---|
| Coefficient of variation (CV) | 1.164823066 |
| Kurtosis | 0.2087986308 |
| Mean | 67460344.07 |
| Median Absolute Deviation (MAD) | 27863859.5 |
| Skewness | 1.219649017 |
| Sum | 1.349206881e+12 |
| Variance | 6.174716572e+15 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 219517861 | 131 | 0.7% | |
| 107434423 | 89 | 0.4% | |
| 30283594 | 53 | 0.3% | |
| 12243051 | 37 | 0.2% | |
| 16098958 | 36 | 0.2% | |
| 137358866 | 36 | 0.2% | |
| 61391963 | 34 | 0.2% | |
| 22541573 | 32 | 0.2% | |
| 200380610 | 27 | 0.1% | |
| 2856748 | 24 | 0.1% | |
| Other values (17017) | 19501 | 97.5% |
| Value | Count | Frequency (%) | |
| 2571 | 1 | < 0.1% | |
| 2787 | 3 | < 0.1% | |
| 3151 | 1 | < 0.1% | |
| 3415 | 1 | < 0.1% | |
| 3563 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 274273284 | 1 | < 0.1% | |
| 274195458 | 1 | < 0.1% | |
| 274103383 | 1 | < 0.1% | |
| 274079964 | 1 | < 0.1% | |
| 273870123 | 1 | < 0.1% |
| Distinct | 6517 |
|---|---|
| Distinct (%) | 32.6% |
| Missing | 8 |
| Missing (%) | < 0.1% |
| Memory size | 156.2 KiB |
| David | 170 |
|---|---|
| Michael | 167 |
| John | 133 |
| Sonder (NYC) | 131 |
| Alex | 105 |
| Other values (6512) |
| Value | Count | Frequency (%) | |
| David | 170 | 0.9% | |
| Michael | 167 | 0.8% | |
| John | 133 | 0.7% | |
| Sonder (NYC) | 131 | 0.7% | |
| Alex | 105 | 0.5% | |
| Daniel | 95 | 0.5% | |
| Blueground | 89 | 0.4% | |
| Sarah | 87 | 0.4% | |
| Maria | 87 | 0.4% | |
| Chris | 83 | 0.4% | |
| Other values (6507) | 18845 | 94.2% |
Unique
| Unique | 4203 ? |
|---|---|
| Unique (%) | 21.0% |
Length
| Max length | 35 |
|---|---|
| Median length | 6 |
| Mean length | 6.1112 |
| Min length | 1 |
neighbourhood_group
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| Manhattan | |
|---|---|
| Brooklyn | |
| Queens | |
| Bronx | 441 |
| Staten Island | 165 |
| Value | Count | Frequency (%) | |
| Manhattan | 8774 | 43.9% | |
| Brooklyn | 8265 | 41.3% | |
| Queens | 2355 | 11.8% | |
| Bronx | 441 | 2.2% | |
| Staten Island | 165 | 0.8% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 13 |
|---|---|
| Median length | 8 |
| Mean length | 8.1783 |
| Min length | 5 |
| Distinct | 217 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| Williamsburg | |
|---|---|
| Bedford-Stuyvesant | |
| Harlem | 1116 |
| Bushwick | 987 |
| Upper West Side | 798 |
| Other values (212) |
| Value | Count | Frequency (%) | |
| Williamsburg | 1580 | 7.9% | |
| Bedford-Stuyvesant | 1503 | 7.5% | |
| Harlem | 1116 | 5.6% | |
| Bushwick | 987 | 4.9% | |
| Upper West Side | 798 | 4.0% | |
| Hell's Kitchen | 771 | 3.9% | |
| East Village | 756 | 3.8% | |
| Upper East Side | 706 | 3.5% | |
| Crown Heights | 648 | 3.2% | |
| Midtown | 643 | 3.2% | |
| Other values (207) | 10492 | 52.5% |
Unique
| Unique | 20 ? |
|---|---|
| Unique (%) | 0.1% |
Length
| Max length | 26 |
|---|---|
| Median length | 12 |
| Mean length | 11.8819 |
| Min length | 4 |
latitude
Real number (ℝ≥0)
| Distinct | 12439 |
|---|---|
| Distinct (%) | 62.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.72845515 |
|---|---|
| Minimum | 40.50873 |
| Maximum | 40.91306 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 156.2 KiB |
Quantile statistics
| Minimum | 40.50873 |
|---|---|
| 5-th percentile | 40.6451295 |
| Q1 | 40.68942 |
| median | 40.72273 |
| Q3 | 40.76299 |
| 95-th percentile | 40.8256525 |
| Maximum | 40.91306 |
| Range | 0.40433 |
| Interquartile range (IQR) | 0.07357 |
Descriptive statistics
| Standard deviation | 0.05475507699 |
|---|---|
| Coefficient of variation (CV) | 0.001344393663 |
| Kurtosis | 0.1085655141 |
| Mean | 40.72845515 |
| Median Absolute Deviation (MAD) | 0.03658 |
| Skewness | 0.2301693808 |
| Sum | 814569.103 |
| Variance | 0.002998118457 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 40.68634 | 8 | < 0.1% | |
| 40.72232 | 8 | < 0.1% | |
| 40.71813 | 8 | < 0.1% | |
| 40.69414 | 8 | < 0.1% | |
| 40.72607 | 7 | < 0.1% | |
| 40.68683 | 7 | < 0.1% | |
| 40.70587 | 7 | < 0.1% | |
| 40.71801 | 7 | < 0.1% | |
| 40.68084 | 7 | < 0.1% | |
| 40.71992 | 6 | < 0.1% | |
| Other values (12429) | 19927 | 99.6% |
| Value | Count | Frequency (%) | |
| 40.50873 | 1 | < 0.1% | |
| 40.52293 | 1 | < 0.1% | |
| 40.53076 | 1 | < 0.1% | |
| 40.53871 | 1 | < 0.1% | |
| 40.53884 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 40.91306 | 1 | < 0.1% | |
| 40.90527 | 1 | < 0.1% | |
| 40.90391 | 1 | < 0.1% | |
| 40.90356 | 1 | < 0.1% | |
| 40.90329 | 1 | < 0.1% |
longitude
Real number (ℝ)
| Distinct | 10181 |
|---|---|
| Distinct (%) | 50.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.95212502 |
|---|---|
| Minimum | -74.23914 |
| Maximum | -73.71795 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 156.2 KiB |
Quantile statistics
| Minimum | -74.23914 |
|---|---|
| 5-th percentile | -74.0041805 |
| Q1 | -73.98303 |
| median | -73.95564 |
| Q3 | -73.93638 |
| 95-th percentile | -73.864896 |
| Maximum | -73.71795 |
| Range | 0.52119 |
| Interquartile range (IQR) | 0.04665 |
Descriptive statistics
| Standard deviation | 0.04655878323 |
|---|---|
| Coefficient of variation (CV) | -0.000629580059 |
| Kurtosis | 4.938242884 |
| Mean | -73.95212502 |
| Median Absolute Deviation (MAD) | 0.024895 |
| Skewness | 1.255100378 |
| Sum | -1479042.5 |
| Variance | 0.002167720296 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| -73.98589 | 10 | 0.1% | |
| -73.94829 | 9 | < 0.1% | |
| -73.95742 | 9 | < 0.1% | |
| -73.95427 | 9 | < 0.1% | |
| -73.95121 | 9 | < 0.1% | |
| -73.98043 | 9 | < 0.1% | |
| -73.95725 | 9 | < 0.1% | |
| -73.95332 | 8 | < 0.1% | |
| -73.95675 | 8 | < 0.1% | |
| -73.95509 | 8 | < 0.1% | |
| Other values (10171) | 19912 | 99.6% |
| Value | Count | Frequency (%) | |
| -74.23914 | 1 | < 0.1% | |
| -74.21238 | 1 | < 0.1% | |
| -74.20295 | 1 | < 0.1% | |
| -74.19826 | 1 | < 0.1% | |
| -74.19626 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| -73.71795 | 1 | < 0.1% | |
| -73.71829 | 1 | < 0.1% | |
| -73.72582 | 1 | < 0.1% | |
| -73.72716 | 1 | < 0.1% | |
| -73.72731 | 1 | < 0.1% |
room_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| Entire home/apt | |
|---|---|
| Private room | |
| Shared room | 444 |
| Value | Count | Frequency (%) | |
| Entire home/apt | 10384 | 51.9% | |
| Private room | 9172 | 45.9% | |
| Shared room | 444 | 2.2% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 13.5354 |
| Min length | 11 |
price
Real number (ℝ≥0)
| Distinct | 544 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 153.26905 |
|---|---|
| Minimum | 0 |
| Maximum | 10000 |
| Zeros | 5 |
| Zeros (%) | < 0.1% |
| Memory size | 156.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 69 |
| median | 105 |
| Q3 | 175 |
| 95-th percentile | 350 |
| Maximum | 10000 |
| Range | 10000 |
| Interquartile range (IQR) | 106 |
Descriptive statistics
| Standard deviation | 243.3256089 |
|---|---|
| Coefficient of variation (CV) | 1.587571717 |
| Kurtosis | 538.297578 |
| Mean | 153.26905 |
| Median Absolute Deviation (MAD) | 45 |
| Skewness | 18.3046896 |
| Sum | 3065381 |
| Variance | 59207.35193 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 100 | 856 | 4.3% | |
| 150 | 821 | 4.1% | |
| 50 | 636 | 3.2% | |
| 200 | 590 | 2.9% | |
| 75 | 570 | 2.9% | |
| 60 | 555 | 2.8% | |
| 80 | 531 | 2.7% | |
| 70 | 482 | 2.4% | |
| 120 | 471 | 2.4% | |
| 65 | 471 | 2.4% | |
| Other values (534) | 14017 | 70.1% |
| Value | Count | Frequency (%) | |
| 0 | 5 | < 0.1% | |
| 10 | 6 | < 0.1% | |
| 11 | 2 | < 0.1% | |
| 12 | 1 | < 0.1% | |
| 13 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10000 | 1 | < 0.1% | |
| 9999 | 1 | < 0.1% | |
| 8500 | 1 | < 0.1% | |
| 7703 | 1 | < 0.1% | |
| 7500 | 1 | < 0.1% |
| Distinct | 75 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.9921 |
|---|---|
| Minimum | 1 |
| Maximum | 1250 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 156.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 30 |
| Maximum | 1250 |
| Range | 1249 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 21.64544903 |
|---|---|
| Coefficient of variation (CV) | 3.095700724 |
| Kurtosis | 1072.167601 |
| Mean | 6.9921 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 25.17996962 |
| Sum | 139842 |
| Variance | 468.5254639 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 5248 | 26.2% | |
| 2 | 4796 | 24.0% | |
| 3 | 3309 | 16.5% | |
| 30 | 1540 | 7.7% | |
| 4 | 1328 | 6.6% | |
| 5 | 1208 | 6.0% | |
| 7 | 855 | 4.3% | |
| 6 | 307 | 1.5% | |
| 14 | 217 | 1.1% | |
| 10 | 183 | 0.9% | |
| Other values (65) | 1009 | 5.0% |
| Value | Count | Frequency (%) | |
| 1 | 5248 | 26.2% | |
| 2 | 4796 | 24.0% | |
| 3 | 3309 | 16.5% | |
| 4 | 1328 | 6.6% | |
| 5 | 1208 | 6.0% |
| Value | Count | Frequency (%) | |
| 1250 | 1 | < 0.1% | |
| 999 | 2 | < 0.1% | |
| 480 | 1 | < 0.1% | |
| 400 | 1 | < 0.1% | |
| 370 | 1 | < 0.1% |
| Distinct | 323 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.2741 |
|---|---|
| Minimum | 0 |
| Maximum | 607 |
| Zeros | 4123 |
| Zeros (%) | 20.6% |
| Memory size | 156.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 5 |
| Q3 | 23 |
| 95-th percentile | 114 |
| Maximum | 607 |
| Range | 607 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 44.92779312 |
|---|---|
| Coefficient of variation (CV) | 1.930377248 |
| Kurtosis | 20.22980666 |
| Mean | 23.2741 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 3.761375507 |
| Sum | 465482 |
| Variance | 2018.506595 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 4123 | 20.6% | |
| 1 | 2131 | 10.7% | |
| 2 | 1394 | 7.0% | |
| 3 | 1033 | 5.2% | |
| 4 | 827 | 4.1% | |
| 5 | 631 | 3.2% | |
| 6 | 560 | 2.8% | |
| 7 | 513 | 2.6% | |
| 8 | 469 | 2.3% | |
| 9 | 400 | 2.0% | |
| Other values (313) | 7919 | 39.6% |
| Value | Count | Frequency (%) | |
| 0 | 4123 | 20.6% | |
| 1 | 2131 | 10.7% | |
| 2 | 1394 | 7.0% | |
| 3 | 1033 | 5.2% | |
| 4 | 827 | 4.1% |
| Value | Count | Frequency (%) | |
| 607 | 1 | < 0.1% | |
| 594 | 1 | < 0.1% | |
| 510 | 1 | < 0.1% | |
| 488 | 1 | < 0.1% | |
| 474 | 1 | < 0.1% |
| Distinct | 1507 |
|---|---|
| Distinct (%) | 9.5% |
| Missing | 4123 |
| Missing (%) | 20.6% |
| Memory size | 156.2 KiB |
| 2019-06-23 | 575 |
|---|---|
| 2019-07-01 | 557 |
| 2019-06-30 | 553 |
| 2019-06-24 | 350 |
| 2019-07-07 | 292 |
| Other values (1502) |
| Value | Count | Frequency (%) | |
| 2019-06-23 | 575 | 2.9% | |
| 2019-07-01 | 557 | 2.8% | |
| 2019-06-30 | 553 | 2.8% | |
| 2019-06-24 | 350 | 1.8% | |
| 2019-07-07 | 292 | 1.5% | |
| 2019-07-02 | 280 | 1.4% | |
| 2019-06-22 | 270 | 1.4% | |
| 2019-07-05 | 252 | 1.3% | |
| 2019-06-16 | 245 | 1.2% | |
| 2019-07-06 | 240 | 1.2% | |
| Other values (1497) | 12263 | 61.3% | |
| (Missing) | 4123 | 20.6% |
Unique
| Unique | 358 ? |
|---|---|
| Unique (%) | 2.3% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 8.55695 |
| Min length | 3 |
| Distinct | 790 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 4123 |
| Missing (%) | 20.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.377445991 |
|---|---|
| Minimum | 0.01 |
| Maximum | 27.95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 156.2 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.04 |
| Q1 | 0.19 |
| median | 0.72 |
| Q3 | 2.01 |
| 95-th percentile | 4.67 |
| Maximum | 27.95 |
| Range | 27.94 |
| Interquartile range (IQR) | 1.82 |
Descriptive statistics
| Standard deviation | 1.683005621 |
|---|---|
| Coefficient of variation (CV) | 1.22183057 |
| Kurtosis | 11.95169963 |
| Mean | 1.377445991 |
| Median Absolute Deviation (MAD) | 0.62 |
| Skewness | 2.435799259 |
| Sum | 21869.71 |
| Variance | 2.83250792 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 378 | 1.9% | |
| 0.02 | 378 | 1.9% | |
| 0.05 | 352 | 1.8% | |
| 0.03 | 334 | 1.7% | |
| 0.04 | 274 | 1.4% | |
| 0.08 | 263 | 1.3% | |
| 0.16 | 255 | 1.3% | |
| 0.09 | 246 | 1.2% | |
| 0.06 | 234 | 1.2% | |
| 0.11 | 222 | 1.1% | |
| Other values (780) | 12941 | 64.7% | |
| (Missing) | 4123 | 20.6% |
| Value | Count | Frequency (%) | |
| 0.01 | 18 | 0.1% | |
| 0.02 | 378 | 1.9% | |
| 0.03 | 334 | 1.7% | |
| 0.04 | 274 | 1.4% | |
| 0.05 | 352 | 1.8% |
| Value | Count | Frequency (%) | |
| 27.95 | 1 | < 0.1% | |
| 20.94 | 1 | < 0.1% | |
| 19.75 | 1 | < 0.1% | |
| 17.82 | 1 | < 0.1% | |
| 16.22 | 1 | < 0.1% |
calculated_host_listings_count
Real number (ℝ≥0)
| Distinct | 47 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.95545 |
|---|---|
| Minimum | 1 |
| Maximum | 327 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 156.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 14 |
| Maximum | 327 |
| Range | 326 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 32.43383053 |
|---|---|
| Coefficient of variation (CV) | 4.663081545 |
| Kurtosis | 70.36535249 |
| Mean | 6.95545 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.096123898 |
| Sum | 139109 |
| Variance | 1051.953363 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 13290 | 66.5% | |
| 2 | 2688 | 13.4% | |
| 3 | 1174 | 5.9% | |
| 4 | 570 | 2.9% | |
| 5 | 361 | 1.8% | |
| 6 | 226 | 1.1% | |
| 8 | 168 | 0.8% | |
| 7 | 166 | 0.8% | |
| 327 | 131 | 0.7% | |
| 9 | 103 | 0.5% | |
| Other values (37) | 1123 | 5.6% |
| Value | Count | Frequency (%) | |
| 1 | 13290 | 66.5% | |
| 2 | 2688 | 13.4% | |
| 3 | 1174 | 5.9% | |
| 4 | 570 | 2.9% | |
| 5 | 361 | 1.8% |
| Value | Count | Frequency (%) | |
| 327 | 131 | 0.7% | |
| 232 | 89 | 0.4% | |
| 121 | 53 | 0.3% | |
| 103 | 36 | 0.2% | |
| 96 | 73 | 0.4% |
| Distinct | 366 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 112.9012 |
|---|---|
| Minimum | 0 |
| Maximum | 365 |
| Zeros | 7176 |
| Zeros (%) | 35.9% |
| Memory size | 156.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 44 |
| Q3 | 229 |
| 95-th percentile | 359 |
| Maximum | 365 |
| Range | 365 |
| Interquartile range (IQR) | 229 |
Descriptive statistics
| Standard deviation | 131.7622264 |
|---|---|
| Coefficient of variation (CV) | 1.167057803 |
| Kurtosis | -1.007092224 |
| Mean | 112.9012 |
| Median Absolute Deviation (MAD) | 44 |
| Skewness | 0.75940929 |
| Sum | 2258024 |
| Variance | 17361.2843 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 7176 | 35.9% | |
| 365 | 510 | 2.5% | |
| 364 | 225 | 1.1% | |
| 1 | 181 | 0.9% | |
| 5 | 136 | 0.7% | |
| 89 | 124 | 0.6% | |
| 179 | 121 | 0.6% | |
| 2 | 119 | 0.6% | |
| 3 | 118 | 0.6% | |
| 4 | 110 | 0.5% | |
| Other values (356) | 11180 | 55.9% |
| Value | Count | Frequency (%) | |
| 0 | 7176 | 35.9% | |
| 1 | 181 | 0.9% | |
| 2 | 119 | 0.6% | |
| 3 | 118 | 0.6% | |
| 4 | 110 | 0.5% |
| Value | Count | Frequency (%) | |
| 365 | 510 | 2.5% | |
| 364 | 225 | 1.1% | |
| 363 | 98 | 0.5% | |
| 362 | 69 | 0.3% | |
| 361 | 48 | 0.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| id | name | host_id | host_name | neighbourhood_group | neighbourhood | latitude | longitude | room_type | price | minimum_nights | number_of_reviews | last_review | reviews_per_month | calculated_host_listings_count | availability_365 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 9138664 | Private Lg Room 15 min to Manhattan | 47594947 | Iris | Queens | Sunnyside | 40.74271 | -73.92493 | Private room | 74 | 2 | 6 | 2019-05-26 | 0.13 | 1 | 5 |
| 1 | 31444015 | TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC | 8523790 | Johlex | Manhattan | Hell's Kitchen | 40.76682 | -73.98878 | Entire home/apt | 170 | 3 | 0 | NaN | NaN | 1 | 188 |
| 2 | 8741020 | Voted #1 Location Quintessential 1BR W Village Apt | 45854238 | John | Manhattan | West Village | 40.73631 | -74.00611 | Entire home/apt | 245 | 3 | 51 | 2018-09-19 | 1.12 | 1 | 0 |
| 3 | 34602077 | Spacious 1 bedroom apartment 15min from Manhattan | 261055465 | Regan | Queens | Astoria | 40.76424 | -73.92351 | Entire home/apt | 125 | 3 | 1 | 2019-05-24 | 0.65 | 1 | 13 |
| 4 | 23203149 | Big beautiful bedroom in huge Bushwick apartment | 143460 | Megan | Brooklyn | Bushwick | 40.69839 | -73.92044 | Private room | 65 | 2 | 8 | 2019-06-23 | 0.52 | 2 | 8 |
| 5 | 4402805 | LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK | 22807362 | Jenny | Brooklyn | Prospect-Lefferts Gardens | 40.66025 | -73.96270 | Entire home/apt | 120 | 3 | 3 | 2018-08-28 | 0.05 | 1 | 16 |
| 6 | 30070126 | ✩Prime Renovated 1/1 Apartment in Upper East Side✩ | 4968673 | Sean | Manhattan | Upper East Side | 40.76831 | -73.95929 | Entire home/apt | 200 | 5 | 2 | 2019-05-26 | 0.68 | 1 | 71 |
| 7 | 34231172 | Fully renovated brick house floor in Brooklyn | 59642348 | Kevin | Brooklyn | Sunset Park | 40.64550 | -74.01262 | Entire home/apt | 95 | 1 | 9 | 2019-07-08 | 9.00 | 1 | 106 |
| 8 | 5856760 | Renovated 1BR in exciting, convenient area | 29408349 | Chad | Manhattan | Chinatown | 40.71490 | -73.99976 | Entire home/apt | 179 | 5 | 7 | 2017-04-18 | 0.14 | 1 | 0 |
| 9 | 7929441 | Beautiful Loft w/ Waterfront View! | 1453898 | Anthony | Brooklyn | Williamsburg | 40.71268 | -73.96676 | Private room | 105 | 2 | 232 | 2019-06-19 | 5.00 | 3 | 64 |
Last rows
| id | name | host_id | host_name | neighbourhood_group | neighbourhood | latitude | longitude | room_type | price | minimum_nights | number_of_reviews | last_review | reviews_per_month | calculated_host_listings_count | availability_365 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19990 | 5192459 | Quiet Room in 4BR UWS Brownstone | 10677483 | Greg | Manhattan | Upper West Side | 40.80173 | -73.96625 | Private room | 70 | 1 | 0 | NaN | NaN | 1 | 0 |
| 19991 | 1327940 | Huge Gorgeous Park View Apartment! | 3290436 | Hadar | Brooklyn | Flatbush | 40.65335 | -73.96257 | Entire home/apt | 120 | 3 | 13 | 2016-08-27 | 0.28 | 2 | 327 |
| 19992 | 23612681 | Shared Room 1 Stop from Manhattan on the F Train | 55724558 | Taylor | Queens | Long Island City | 40.76006 | -73.94080 | Private room | 55 | 4 | 2 | 2019-06-01 | 0.65 | 5 | 89 |
| 19993 | 34485745 | Midtown Manhattan Stunner - Private room | 261632622 | Royalton | Manhattan | Theater District | 40.75491 | -73.98507 | Private room | 100 | 1 | 3 | 2019-06-16 | 3.00 | 9 | 318 |
| 19994 | 25616250 | Stylish, spacious, private 1BR apt in Ditmas Park | 125396920 | Adam | Brooklyn | Flatbush | 40.64314 | -73.95705 | Entire home/apt | 75 | 3 | 10 | 2019-01-03 | 0.84 | 1 | 0 |
| 19995 | 7094539 | Tranquil haven in bubbly Brooklyn | 2052211 | Adriana | Brooklyn | Windsor Terrace | 40.65360 | -73.97546 | Entire home/apt | 143 | 14 | 2 | 2016-08-27 | 0.04 | 1 | 10 |
| 19996 | 4424261 | Large 1 BR with backyard on UWS | 3447311 | Sarah | Manhattan | Upper West Side | 40.80188 | -73.96808 | Entire home/apt | 200 | 2 | 22 | 2019-05-21 | 0.50 | 1 | 0 |
| 19997 | 4545882 | Amazing studio/Loft with a backyard | 23569951 | Kaveh | Manhattan | Upper East Side | 40.78110 | -73.94567 | Entire home/apt | 220 | 3 | 28 | 2019-05-23 | 0.50 | 1 | 293 |
| 19998 | 26518547 | U2 comfortable double bed sleeps 2 guests | 295128 | Carol Gloria | Bronx | Clason Point | 40.81225 | -73.85502 | Private room | 80 | 1 | 4 | 2019-07-01 | 1.48 | 7 | 365 |
| 19999 | 33631782 | Private Bedroom in Williamsburg Apt! | 8569221 | Andi | Brooklyn | Williamsburg | 40.71829 | -73.95819 | Private room | 109 | 3 | 3 | 2019-04-28 | 1.07 | 2 | 97 |